Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	390
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	42.8 KiB
Average record size in memory	112.3 B

Variable types

NUM	12
CAT	2

Warnings

`Age` is highly correlated with `Patient number`	High correlation
`Patient number` is highly correlated with `Age`	High correlation
`Patient number` has unique values	Unique

Reproduction

Analysis started	2021-08-22 04:39:29.145351
Analysis finished	2021-08-22 04:39:54.286342
Duration	25.14 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

Patient number
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	390
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	195.5
Minimum	1
Maximum	390
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	1
5-th percentile	20.45
Q1	98.25
median	195.5
Q3	292.75
95-th percentile	370.55
Maximum	390
Range	389
Interquartile range (IQR)	194.5

Descriptive statistics

Standard deviation	112.7275477
Coefficient of variation (CV)	0.5766114969
Kurtosis	-1.2
Mean	195.5
Median Absolute Deviation (MAD)	97.5
Skewness	0
Sum	76245
Variance	12707.5
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	0.3%
245	1	0.3%
267	1	0.3%
266	1	0.3%
265	1	0.3%
264	1	0.3%
263	1	0.3%
262	1	0.3%
261	1	0.3%
260	1	0.3%
Other values (380)	380	97.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	0.3%
2	1	0.3%
3	1	0.3%
4	1	0.3%
5	1	0.3%

Value	Count	Frequency (%)
390	1	0.3%
389	1	0.3%
388	1	0.3%
387	1	0.3%
386	1	0.3%

Cholesterol
Real number (ℝ_≥0)

Distinct	153
Distinct (%)	39.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	207.2307692
Minimum	78
Maximum	443
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	78
5-th percentile	144.45
Q1	179
median	203
Q3	229
95-th percentile	290.65
Maximum	443
Range	365
Interquartile range (IQR)	50

Descriptive statistics

Standard deviation	44.66600505
Coefficient of variation (CV)	0.2155375151
Kurtosis	2.679798277
Mean	207.2307692
Median Absolute Deviation (MAD)	25
Skewness	0.9617766361
Sum	80820
Variance	1995.052007
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
179	11	2.8%
204	9	2.3%
215	7	1.8%
219	7	1.8%
194	7	1.8%
203	6	1.5%
199	6	1.5%
174	5	1.3%
193	5	1.3%
160	5	1.3%
Other values (143)	322	82.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
78	1	0.3%
115	1	0.3%
118	1	0.3%
122	1	0.3%
128	1	0.3%

Value	Count	Frequency (%)
443	1	0.3%
404	1	0.3%
347	1	0.3%
342	1	0.3%
337	1	0.3%

Glucose
Real number (ℝ_≥0)

Distinct	116
Distinct (%)	29.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	107.3384615
Minimum	48
Maximum	385
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	48
5-th percentile	68
Q1	81
median	90
Q3	107.75
95-th percentile	234.1
Maximum	385
Range	337
Interquartile range (IQR)	26.75

Descriptive statistics

Standard deviation	53.79818813
Coefficient of variation (CV)	0.5012014087
Kurtosis	7.905912867
Mean	107.3384615
Median Absolute Deviation (MAD)	12
Skewness	2.711121324
Sum	41862
Variance	2894.245046
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
85	18	4.6%
81	15	3.8%
92	14	3.6%
87	12	3.1%
84	12	3.1%
83	11	2.8%
77	11	2.8%
91	10	2.6%
82	10	2.6%
76	10	2.6%
Other values (106)	267	68.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
48	1	0.3%
52	1	0.3%
54	1	0.3%
56	2	0.5%
57	1	0.3%

Value	Count	Frequency (%)
385	1	0.3%
371	1	0.3%
369	1	0.3%
342	1	0.3%
341	1	0.3%

HDL Chol
Real number (ℝ_≥0)

Distinct	75
Distinct (%)	19.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	50.26666667
Minimum	12
Maximum	120
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	12
5-th percentile	29.45
Q1	38
median	46
Q3	59
95-th percentile	85.55
Maximum	120
Range	108
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	17.27906937
Coefficient of variation (CV)	0.3437480643
Kurtosis	2.123071215
Mean	50.26666667
Median Absolute Deviation (MAD)	10
Skewness	1.228957201
Sum	19604
Variance	298.5662382
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
46	21	5.4%
44	20	5.1%
36	20	5.1%
34	18	4.6%
42	15	3.8%
40	14	3.6%
54	11	2.8%
37	11	2.8%
58	9	2.3%
48	9	2.3%
Other values (65)	242	62.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12	1	0.3%
14	1	0.3%
23	1	0.3%
24	5	1.3%
25	1	0.3%

Value	Count	Frequency (%)
120	1	0.3%
118	1	0.3%
117	1	0.3%
114	1	0.3%
110	1	0.3%

Age
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	68
Distinct (%)	17.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	46.77435897
Minimum	19
Maximum	92
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	19
5-th percentile	22
Q1	34
median	44.5
Q3	60
95-th percentile	76
Maximum	92
Range	73
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	16.43591149
Coefficient of variation (CV)	0.3513872099
Kurtosis	-0.6631610993
Mean	46.77435897
Median Absolute Deviation (MAD)	13.5
Skewness	0.3329066708
Sum	18242
Variance	270.1391866
Monotocity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40	16	4.1%
36	13	3.3%
43	12	3.1%
41	12	3.1%
37	11	2.8%
38	11	2.8%
63	11	2.8%
20	10	2.6%
50	10	2.6%
60	10	2.6%
Other values (58)	274	70.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
19	2	0.5%
20	10	2.6%
21	6	1.5%
22	5	1.3%
23	7	1.8%

Value	Count	Frequency (%)
92	1	0.3%
91	1	0.3%
89	1	0.3%
84	1	0.3%
83	1	0.3%

Gender
Categorical

Distinct	2
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	3.0 KiB

female	228
male	162

Frequencies
Length

Value	Count	Frequency (%)
female	228	58.5%
male	162	41.5%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	6
Median length	6
Mean length	5.169230769
Min length	4

Height
Real number (ℝ_≥0)

Distinct	22
Distinct (%)	5.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	65.95128205
Minimum	52
Maximum	76
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	52
5-th percentile	60
Q1	63
median	66
Q3	69
95-th percentile	72
Maximum	76
Range	24
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.918866881
Coefficient of variation (CV)	0.05942063231
Kurtosis	-0.200402077
Mean	65.95128205
Median Absolute Deviation (MAD)	3
Skewness	0.02997564612
Sum	25721
Variance	15.35751763
Monotocity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
63	40	10.3%
69	36	9.2%
67	36	9.2%
65	34	8.7%
64	33	8.5%
62	33	8.5%
66	32	8.2%
68	26	6.7%
70	22	5.6%
71	21	5.4%
Other values (12)	77	19.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
52	1	0.3%
55	1	0.3%
56	1	0.3%
58	3	0.8%
59	9	2.3%

Value	Count	Frequency (%)
76	2	0.5%
75	3	0.8%
74	5	1.3%
73	8	2.1%
72	14	3.6%

Weight
Real number (ℝ_≥0)

Distinct	139
Distinct (%)	35.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	177.4076923
Minimum	99
Maximum	325
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	99
5-th percentile	119
Q1	150.25
median	173
Q3	200
95-th percentile	255.55
Maximum	325
Range	226
Interquartile range (IQR)	49.75

Descriptive statistics

Standard deviation	40.40782385
Coefficient of variation (CV)	0.2277681612
Kurtosis	0.7640335329
Mean	177.4076923
Median Absolute Deviation (MAD)	25
Skewness	0.7404730913
Sum	69189
Variance	1632.792229
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
170	13	3.3%
145	11	2.8%
183	10	2.6%
179	10	2.6%
180	9	2.3%
165	9	2.3%
160	8	2.1%
200	8	2.1%
167	7	1.8%
185	6	1.5%
Other values (129)	299	76.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
99	1	0.3%
100	1	0.3%
102	1	0.3%
105	2	0.5%
109	1	0.3%

Value	Count	Frequency (%)
325	1	0.3%
320	1	0.3%
308	1	0.3%
290	1	0.3%
289	1	0.3%

BMI
Real number (ℝ_≥0)

Distinct	193
Distinct (%)	49.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	28.77564103
Minimum	15.2
Maximum	55.8
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	15.2
5-th percentile	19.5
Q1	24.1
median	27.8
Q3	32.275
95-th percentile	41.41
Maximum	55.8
Range	40.6
Interquartile range (IQR)	8.175

Descriptive statistics

Standard deviation	6.600914985
Coefficient of variation (CV)	0.2293924566
Kurtosis	0.8920563266
Mean	28.77564103
Median Absolute Deviation (MAD)	4
Skewness	0.8207569129
Sum	11222.5
Variance	43.57207864
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30.1	9	2.3%
27.8	7	1.8%
27.5	6	1.5%
25.8	5	1.3%
27.4	5	1.3%
26.9	5	1.3%
25.1	5	1.3%
29.9	5	1.3%
24.5	5	1.3%
26	4	1.0%
Other values (183)	334	85.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
15.2	1	0.3%
16	1	0.3%
17.2	2	0.5%
17.7	1	0.3%
17.8	1	0.3%

Value	Count	Frequency (%)
55.8	1	0.3%
51.4	1	0.3%
50.5	1	0.3%
48.6	1	0.3%
48.4	1	0.3%

Systolic BP
Real number (ℝ_≥0)

Distinct	71
Distinct (%)	18.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	137.1333333
Minimum	90
Maximum	250
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	90
5-th percentile	106.9
Q1	122
median	136
Q3	148
95-th percentile	179.55
Maximum	250
Range	160
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	22.85952782
Coefficient of variation (CV)	0.1666956331
Kurtosis	2.392026226
Mean	137.1333333
Median Absolute Deviation (MAD)	14
Skewness	1.098757147
Sum	53482
Variance	522.558012
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
140	36	9.2%
130	30	7.7%
110	26	6.7%
138	19	4.9%
120	18	4.6%
150	17	4.4%
142	16	4.1%
136	13	3.3%
122	13	3.3%
118	12	3.1%
Other values (61)	190	48.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
90	1	0.3%
98	1	0.3%
100	7	1.8%
102	2	0.5%
103	1	0.3%

Value	Count	Frequency (%)
250	1	0.3%
230	1	0.3%
220	1	0.3%
218	1	0.3%
212	1	0.3%

Diastolic BP
Real number (ℝ_≥0)

Distinct	56
Distinct (%)	14.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	83.28974359
Minimum	48
Maximum	124
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	48
5-th percentile	62
Q1	75
median	82
Q3	90
95-th percentile	109.1
Maximum	124
Range	76
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	13.49819173
Coefficient of variation (CV)	0.1620630722
Kurtosis	0.1141557845
Mean	83.28974359
Median Absolute Deviation (MAD)	8
Skewness	0.245827774
Sum	32483
Variance	182.2011799
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90	37	9.5%
80	29	7.4%
78	22	5.6%
82	22	5.6%
70	17	4.4%
88	16	4.1%
86	16	4.1%
100	16	4.1%
75	14	3.6%
76	14	3.6%
Other values (46)	187	47.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
48	1	0.3%
50	2	0.5%
52	1	0.3%
53	1	0.3%
56	1	0.3%

Value	Count	Frequency (%)
124	1	0.3%
122	1	0.3%
120	2	0.5%
118	2	0.5%
115	2	0.5%

waist
Real number (ℝ_≥0)

Distinct	30
Distinct (%)	7.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	37.86923077
Minimum	26
Maximum	56
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	26
5-th percentile	29
Q1	33
median	37
Q3	41
95-th percentile	48
Maximum	56
Range	30
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	5.760947055
Coefficient of variation (CV)	0.1521273852
Kurtosis	-0.1536526614
Mean	37.86923077
Median Absolute Deviation (MAD)	4
Skewness	0.4753161478
Sum	14769
Variance	33.18851097
Monotocity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
37	31	7.9%
40	27	6.9%
38	27	6.9%
33	27	6.9%
36	25	6.4%
39	23	5.9%
34	23	5.9%
32	22	5.6%
31	21	5.4%
35	19	4.9%
Other values (20)	145	37.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
26	2	0.5%
27	1	0.3%
28	7	1.8%
29	11	2.8%
30	10	2.6%

Value	Count	Frequency (%)
56	1	0.3%
55	1	0.3%
53	2	0.5%
52	2	0.5%
51	4	1.0%

hip
Real number (ℝ_≥0)

Distinct	32
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	42.99230769
Minimum	30
Maximum	64
Zeros	0
Zeros (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	30
5-th percentile	35
Q1	39
median	42
Q3	46
95-th percentile	54
Maximum	64
Range	34
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	5.66434229
Coefficient of variation (CV)	0.1317524598
Kurtosis	0.8625715722
Mean	42.99230769
Median Absolute Deviation (MAD)	3
Skewness	0.7943390011
Sum	16767
Variance	32.08477358
Monotocity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
41	35	9.0%
39	35	9.0%
40	33	8.5%
43	28	7.2%
38	28	7.2%
42	27	6.9%
47	22	5.6%
44	21	5.4%
46	20	5.1%
45	20	5.1%
Other values (22)	121	31.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
30	1	0.3%
32	1	0.3%
33	8	2.1%
34	6	1.5%
35	11	2.8%

Value	Count	Frequency (%)
64	1	0.3%
62	2	0.5%
60	1	0.3%
59	1	0.3%
58	5	1.3%

Diabetes
Categorical

Distinct	2
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	3.0 KiB

No diabetes	330
Diabetes	60

Frequencies
Length

Value	Count	Frequency (%)
No diabetes	330	84.6%
Diabetes	60	15.4%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	11
Median length	11
Mean length	10.53846154
Min length	8

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

First rows

	Patient number	Cholesterol	Glucose	HDL Chol	Age	Gender	Height	Weight	BMI	Systolic BP	Diastolic BP	waist	hip	Diabetes
0	1	193	77	49	19	female	61	119	22.5	118	70	32	38	No diabetes
1	2	146	79	41	19	female	60	135	26.4	108	58	33	40	No diabetes
2	3	217	75	54	20	female	67	187	29.3	110	72	40	45	No diabetes
3	4	226	97	70	20	female	64	114	19.6	122	64	31	39	No diabetes
4	5	164	91	67	20	female	70	141	20.2	122	86	32	39	No diabetes
5	6	170	69	64	20	female	64	161	27.6	108	70	37	40	No diabetes
6	7	149	77	49	20	female	62	115	21.0	105	82	31	37	No diabetes
7	8	164	71	63	20	male	72	145	19.7	108	78	29	36	No diabetes
8	9	230	112	64	20	male	67	159	24.9	100	90	31	39	No diabetes
9	10	179	105	60	20	female	58	170	35.5	140	100	34	46	No diabetes

Last rows

	Patient number	Cholesterol	Glucose	HDL Chol	Age	Gender	Height	Weight	BMI	Systolic BP	Diastolic BP	waist	hip	Diabetes
380	381	157	92	47	80	male	71	212	29.6	156	88	47	48	No diabetes
381	382	252	161	87	80	female	62	162	29.6	160	100	44	41	Diabetes
382	383	271	121	40	81	female	64	158	27.1	146	76	36	43	No diabetes
383	384	240	88	49	82	female	63	170	30.1	180	86	41	46	No diabetes
384	385	255	112	34	82	male	66	163	26.3	179	89	37	43	No diabetes
385	386	227	105	44	83	female	59	125	25.2	150	90	35	40	No diabetes
386	387	226	279	52	84	female	60	192	37.5	144	88	41	48	Diabetes
387	388	301	90	118	89	female	61	115	21.7	218	90	31	41	No diabetes
388	389	232	184	114	91	female	61	127	24.0	170	82	35	38	Diabetes
389	390	165	94	69	92	female	62	217	39.7	160	82	51	51	No diabetes

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows